# 🗄️ Week 7 — SQL & Artificial Intelligence · Problem Sets & Labs

> Complete CS50x solutions for **Week 7: SQL & AI**, engineered by **Ayman Elmasry — AEL Digital Studio**.

## 📋 Contents

| Problem Set | Solution Code | Category |
|-------------|---------------|----------|
| **Movies** | [`movies/*.sql`](Problem%20Set%207/movies/) | SQL Querying (IMDb database) |
| **Fiftyville** | [`fiftyville/*.sql`](Problem%20Set%207/fiftyville/) | Crime Investigation |
| **Lab 7: Songs** | [`lab7/songs/*.sql`](lab7/songs/) | SQL Aggregate Queries |

## 🛠 Run

```bash
sqlite3 fiftyville.db < log.sql       # → the thief is revealed
sqlite3 songs.db < 8.sql
```

> **Note:** `movies.sql` queries require the official `movies.db` (≈129 MB) from the CS50 distribution, which is too large to host on GitHub. Download it from the CS50x problem set page and place it in `Problem Set 7/movies/`:
> ```
> cd "Problem Set 7/movies"
> curl -LO <official-cs50-movies.db-url>   # or via your CS50 codespace
> ```

---
**© Ayman Elmasry — AEL Digital Studio™ · All Rights Reserved.**